package top.didi.study.javawebjdbc.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBHelper {
    public static final String URL=
    "jdbc:mysql://teach_mysql.huhuiyu.top:31000/db_hesisi?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai";
     public static final String USER="db_hesisi";
     public static final String PASSWORD="hss123456";
     public static final String DRIVER="com.mysql.cj.jdbc.Driver";

     static {
         //加载驱动程序
         try {
             Class.forName(DRIVER);
         } catch (ClassNotFoundException e) {
             throw new RuntimeException(e);
         }
     }

     //获取数据库的链接
    public static Connection getConnection() {
        try {
            return DriverManager.getConnection(URL,USER,PASSWORD);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }

    }


}
